package com.unicom.projt.db;

/**
 * Created by IntelliJ IDEA.
 * User: Lee
 * Date: 11-12-7
 * Time: 下午4:47
 */
public class DBConfig {
    public static final String DB_NAME = "projt.db";
    public static final int DB_VERSION = 0x00000001;


    public static class Account {

        public static final String TABLE_NAME = "account";

        public static final String ID = "id";
        public static final String PHONE_NUMBER = "phone_number";
        public static final String PASSWORD = "password";
        public static final String REMEMBER = "remember";

        public static final String CREATE_ACCOUNT = "create table " + TABLE_NAME +
                "(" +
                ID + " integer primary key autoincrement, " + PHONE_NUMBER + " TEXT, " +
                PASSWORD + " TEXT, " + REMEMBER + " TEXT" +
                ");";
    }

    public static class PaymentRecord {
        public static final String TABLE_NAME = "payment_record";

        public static final String ID = "id";
        public static final String PAYMENT_TYPE = "payment_type";
        public static final String PHONE_NUMBER = "phone_number";
        public static final String PAYMENT_DATE = "payment_date";
        public static final String PAYMENT_AMOUNT = "payment_amount";

        public static final String CREATE_PAYMENTRECORD = "create table " + TABLE_NAME +
                "(" +
                ID + " integer primary key autoincrement, " + PAYMENT_TYPE + " TEXT, " + PHONE_NUMBER + " TEXT, " + PAYMENT_DATE + " DATE, " + PAYMENT_AMOUNT + " TEXT"
                + ");";
    }
}
